Sets or returns the underlying data value in a column for the current row. Not available at design time.
Syntax
object.Value [= value]
The Value property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
value | A string expression that represents the underlying data value in a column for the current row. |
Remarks
The Value property is useful for simulating data entry within a cell. When this property is set, the value displayed in the cell respects the setting of the column's NumberFormat property.
This property always returns a string variant, even if the data type of the underlying field is numeric.
Use the Text property to access the formatted data value in a column for the current row.